概要

Database administrator (DBA) with around 11 years extensive experience of designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL Server environments.
Implementing RAC, Data guard, backup and recovery strategies, database cloning, performance tuning, Golden Gate and implementing business logic using sql,Pl/Sql functions, packages and triggers.
Proficient in an assortment of technologies, including Oracle 12c, DB2, MS SQL Server 2014 ,My Sql NDB cluster ,PostgreSql ,Mongo DB , Windows and Linux.
Vast experience of different domains like Textile, Telecom, Medical record keeping and billing and Oil &Gas

项目

Corporate Data Store™ E&P Master Database Software
OpenWorks (Project Data Management Software)
VO8
Cutting Production System
International Traffic Settlement System.
EServicesManager™ (eSM)
SequelMed® EHR™ (Electronic Health Records)

工作经历

公司标识
Senior Database Administrator
LMKR
Aug 2017 - 代表 | Islamabad, Pakistan

• Working as Corporate Data Store (CDS) and OpenWorks Database administrator.
• Setup RAC from scratch and Management of Oracle11gR2 Real Application Cluster and Grid infrastructure.
• Add and remove node from Cluster.
• Configuration and Administration of Standby Database with Oracle Data Guard.
• Using RMAN to create Incremental Backups, manage and configure backup policy and automate it to ensure that database backups are working according to backup and recovery policy.
• Good skills in Oracle Data Pump Utility, Export and Import Utility and SQL Loader.
• Working with Oracle Golden Gate to duplicate, backup database to other systems.
• Good experience of managing ASM instance.
• Database software installation, patching and cloning.
• Expertise in managing Table spaces, Data files, Users and Privileges, Tables, Schema, Materialized Views ,indexes ,partitioning and other database objects.
• Experience in Data Warehouse database design, database support and maintenance, Security, monitoring and troubleshooting, Capacity planning, Partitioning.
• Sql,Pl/Sql and Database Performance tuning using Oracle Enterprise manager , Oracle Trace, Explain Plan.
• Using SSIS and Sql scripts to write ETL jobs to migrate data.
• Writing Optimized SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, and Views

公司标识
Database Administrator
LMKT
Aug 2016 - Jul 2017 | Islamabad, Pakistan

• Working Experience of Configuration and Management of Oracle11gR2 RAC, ASM infrastructure.
• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.
• Configuration and Administration of Standby Database with Oracle Active Data Guard.
• Expertise in RMAN to create Incremental Backups, manage and configure backup policy and automate it to ensure that database backups are working according to backup and recovery policy.
• Database Upgrades, Migrations, Cloning, Patching, and troubleshooting various databases
• Expertise in managing Table spaces, Data files, Users and Privileges, Tables, Schema, Materialized Views, Indexes and other database objects.
• Implementing Virtual Private Database (VPD),Implementing Oracle Label Security (OLS) , Working knowledge of Transparent Data Encryption (TDE) and Basic knowledge of Oracle Data Redaction (ODR)
• Managing Full-Text Indexing
• Implementation Database replication, database mirroring.
• Creating and managing MySQL on NDB cluster.
• Managing PostgreSQL database. Implementing PostgreSQL database replication, switchover and failover.
• Managing Sql Server 2014 database implementing backup and recovery for Sql server database, scheduling jobs, writing store procedures, functions.
• Migrating data to and from Sql server database.
• IBM DB2 and Mongo DB Database Administration and development.

公司标识
Senior Database Administrator
LMKR
Aug 2012 - Jul 2016 | Islamabad, Pakistan

• Setup RAC from scratch and Management of Oracle11gR2 Real Application Cluster and Grid infrastructure.
• Configuration and Administration of Standby Database with Oracle Data Guard.
• Using RMAN to create Incremental Backups, manage and configure backup policy and automate it to ensure that database backups are working according to backup and recovery policy.
• Good skills in Oracle Data Pump Utility, Export and Import Utility and SQL Loader.
• Good experience of managing ASM instance.
• Database software installation, patching and cloning.
• Expertise in managing Table spaces, Data files, Users and Privileges, Tables, Schema, Materialized Views ,indexes ,partitioning and other database objects.
• Set up and manage database security creating new users, roles, profiles, and grant required user privileges.
• Sql,Pl/Sql and Database Performance tuning using Oracle Enterprise manager , Oracle Trace, Explain Plan.
• Writing Optimized SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, and Views and Materialized Views.

公司标识
Pl/Sql Developer DBA
Sequel Systems.Inc,(US Based company)
Oct 2010 - Aug 2012 | Rawalpindi, Pakistan

• Administer production and development databases, ensuring maximum availability.
• Design, implement and operate database systems for performance and reliability.
• Ensure that storage, archiving, back-up and recovery procedures are functioning correctly
• Apply business Logic through Procedure, Functions and Packages triggers and writing complex queries.
• Work with customers in data migration projects to build migration scripts and integrate with customer’s existing databases and/or data feeds
• Review database design and code written by other database and software engineers.
• Writing ETL scripts and provide technical assistance to BI development, application Development and support team.

公司标识
DB Software Engineer
HIQU Systems
May 2010 - Nov 2010 | Islamabad, Pakistan

• Using SQL Server 2000, 2005, 2008 database administration and development.
• Applying Backup and Recovery methods, backup tuning and troubleshooting
• Involved in designing, developing and deploying application.
• Apply business Logic through Procedure, Functions and Packages triggers and writing complex queries.
• Providing Support to off sure clients.

公司标识
Software Engineer
Computer Research (Pvt) Ltd
Apr 2009 - May 2010 | Islamabad, Pakistan

• Working experience in Oracle forms ,Oracle reports ,Oracle graphic
• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.
• Write Ad hock queries to generate different reports and to extract data for analysis and decision making.
• Managing database, creating Users and Privileges, Tables, Schema, Materialized Views, Adding tablespace, Data files.

公司标识
Software Developer
Masood Textile Mills Division Sheikhupura road Faisalabad.
Sep 2006 - Apr 2009 | Faisalabad, Pakistan

• Working experience in Oracle Forms ,Oracle Reports ,Oracle graphic
• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.
• Write complex queries to generate different reports and to extract data for analysis and decision making.
• Writing Ad hock queries to extract data for analysis purpose

学历

Allama Iqbal Medical College
学士, , BS (4 years)‎
Computer Science
所占比重 65%
2006
Punjab Board of Technical Education Lahore
中级/A级, , DAE in Computer Hardware Technology‎
Computer Science
2002

技能

中级 12c
熟练 CVs Screening
熟练 ETL
熟练 Linux Administration
熟练 Oracle 11g
熟练 Query Language
熟练 RAC
熟练 VMware Workstation

语言

熟练 英语

关注的公司